!*SEQ2.08 06/29/16 DDLGSEMX8000 DDL PI80DDL ! ?page "header and modification history" **********************************************************************!!00003 * *!!00004 * BASE24 *!!00005 * ------ *!!00006 * *!!00007 * PRISM Components *!!00008 * *!!00009 * SEMFXD - Scoring Engine Master File Refresh Format *!!00010 * *!!00011 * Proprietary Software Product *!!00012 * *!!00013 * ACI Worldwide Inc. *!!00014 * 330 South 108th Avenue *!!00015 * Omaha, Nebraska 68154 *!!00016 * (402) 390-7600 *!!00017 * *!!00018 * Copyright by ACI Worldwide Inc. 2016 *!!00019 * *!!00020 * All Rights Reserved. No part of this document may be *!!00021 * reproduced in any manner without the prior written consent of *!!00022 * ACI Worldwide Inc. This material is a trade secret and its *!!00023 * confidentiality is strictly maintained. Use of any copyright *!!00024 * notice does not imply unrestricted or public access to these *!!00025 * materials. *!!00026 * *!!00027 * BASE24 (R) is a registered trademark of ACI Worldwide Inc. *!!00028 * *!!00029 **********************************************************************!!00030 !00031 ?page * Record of Changes: !!00034 * !!00035 * Date Person/Emp # !!00036 * --------- ------------ !!00037 * 27OCT2000 cal/246 !!00038 * Symptom: BASE24 Release 5.3 PRISM Components !!00039 * Problem: None. !!00040 * Fix: Initial Release 5.3 !!00041 * Dependency: Customers should refer to the update guide, !!00042 * PI53SRC.PRMUPDT, when making the code with the !!00043 * prm_on flag set to true. !!00044 * Reference: WO #000613-001 !!00045 !00046 *#################################################################### !!00047 * Release 6.1 # !!00048 *#################################################################### !!00049 * 15JUN2002 KSS/718 !!00050 * Symptom: BASE24 Release 6.1 PRM Components !!00051 * Problem: None. !!00052 * Fix: Initial Release 6.1 !!00053 * Dependency: Customers should refer to the update guide, !!00054 * PI61SRC.PRMUPDT, when making the code with the !!00055 * prm_on flag set to true. !!00056 * Reference: WO #020615-001 !!00057 !00058 !00059 *###################################################################! !!00060 * Release 7.0 ! !!00061 *###################################################################! !!00062 * 18DEC2003 WILWERK !!00063 * Symptom: BASE24 Release 7.0 PRM Components !!00064 * Problem: None. !!00065 * Fix: Initial Release 7.0 !!00066 * Dependency: Customers should refer to the update guide, !!00067 * PI70SRC.PRMUPDT, when making the code with the !!00068 * prm_on flag set to true. !!00069 * Reference: WO #000070-001 !!00070 !00071 * 01NOV2004 WILWERK !!00072 * Symptom: Encountered error during SEMF refresh. !!00073 * Problem: There is a mismatch between the SEMF DDL and !!00074 * the SEMF Refresh DDL. !!00075 * Fix: Removed the fields crd.cvv2, crd.stat and !!00076 * crd.rate^clas from the SEMF refresh DDL. !!00077 * Dependency: Apply fix to DDLGSEMX and run Make. !!00078 * Reference: Case #386794 !!00079 !00080 * 28DEC2004 WILWERK !!00081 * Symptom: PRM Interface Process Enterprise Risk Enhancement !!00082 * Problem: None. !!00083 * Fix: Redefined fields for use in the ER product. !!00084 * Dependency: Apply fix to SEIPG, SCRNSEIP, RQSEIPS, DDLFERIF, !!00085 * DDLFSEMF, DDLGSEMX, PIDDLMM, PIDDLM, SEIPDDLM, !!00086 * SCRNSEMF and SEIPS and remake. !!00087 * Reference: WO #000070-002 !!00088 *###################################################################! !!00089 * Release 8.0 ! !!00090 *###################################################################! !!00091 * 16JUN2016 PandeyA !!00092 * Symptom: BASE24 Release 8.0 PRM Components !!00093 * Problem: None. !!00094 * Fix: Initial Release 8.0 !!00095 * Dependency: Customers should refer to the update guide, !!00096 * PI80SEIP.PIPUPDT, when making the code with the !!00097 * prm_on flag set to true. !!00098 * Reference: WO #077601 !!00099 !00100 ?PAGE "SEMFXD - Scoring Engine Master File Refresh Format" ?SECTION SEMFXD !00105 **********************************************************************!!00106 * !!00107 * !!00108 * SCORING ENGINE MASTER FILE REFRESH FORMAT !!00109 * !!00110 * !!00111 * DESCRIPTION !!00112 * !!00113 * This file is used by PRISM. !!00114 * !!00115 * The Scoring Engine Master File (SEMF) will contain !!00116 * cardholder and account information which is not !!00117 * currently found elsewhere in BASE24. The SEMF will be !!00118 * read by the Scoring Engine Input Process. Data from !!00119 * the SEMF and the STM/PSTM will be used to create records !!00120 * which will be written to the Scoring Engine Input File !!00121 * (SEIF). !!00122 * !!00123 * The SEMF may be updated by a full-file or partial Refresh !!00124 * using the format below. The SEMF may also be updated via !!00125 * From Host Maintenance or Pathway. !!00126 * !!00127 **********************************************************************!!00128 !00129 DEFINITION SEMFXD. !00130 !00131 * !!00132 * A record number indicating the position of !!00133 * this record on the refresh tape. The value !!00134 * in this field should always be one greater !!00135 * than that in the previous record on the tape. !!00136 * !!00137 * Header and trailer records must be reflected !!00138 * in this count as well as individual SEMF records. !!00139 * !!00140 !00141 02 SEMFXD-CNT PIC 9(9). !00142 !00143 * !!00144 * A code indicating the operation to be !!00145 * performed on the SEMF record. !!00146 * Valid values are: !!00147 * !!00148 * A = Add !!00149 * C = Change !!00150 * D = Delete !!00151 * F = Full-file change !!00152 * !!00153 * Values of A, C, and D are intended for use !!00154 * with partial-file refreshes. The value F !!00155 * is required for full-file refreshes. !!00156 * !!00157 !00158 02 SEMFXD-REC-TYP PIC X. !00159 !00160 * !!00161 * The primary key to the SEMF. !!00162 * !!00163 !00164 02 PRIKEY. !00165 !00166 * !!00167 * The FIID or ABA number of the financial !!00168 * institution that issued the card. This !!00169 * value must be unique within the logical !!00170 * network. !!00171 * !!00172 !00173 04 FIID PIC X(9). !00174 !00175 * !!00176 * The card number (PAN) identifying the card !!00177 * (left-justified, blank-filled). This field !!00178 * contains the card number carried in Track 2 !!00179 * of the card. BASE24 currently supports a !!00180 * 19-digit maximum PAN length. !!00181 * !!00182 !00183 04 PAN PIC X(19). !00184 !00185 * !!00186 * Personal information about the cardholder. !!00187 * !!00188 !00189 02 USER. !00190 !00191 * !!00192 * The card number (PAN) identifying the previous !!00193 * card for this cardholder (left-justified, !!00194 * blank-filled). Default is spaces. !!00195 * !!00196 !00197 04 PREV-CRD-NUM PIC X(19). !00198 !00199 * !!00200 * The Unified Account Number. May or may not be !!00201 * similar to the PAN. Used in the Enterprise Risk !!00202 * solution. !!00203 * !!00204 !00205 04 ER-UNI-ACCT-NUM REDEFINES PREV-CRD-NUM PIC X(19). !00206 !00207 !00208 * !!00209 * The name of the primary cardholder. !!00210 * Default is spaces. !!00211 * !!00212 !00213 04 PRI-NAM PIC X(40). !00214 !00215 * !!00216 * Social security number of the primary !!00217 * cardholder. Default is spaces. !!00218 * !!00219 !00220 04 PRI-GOVT-ID PIC X(20). !00221 !00222 * !!00223 * The primary cardholder's date of birth !!00224 * in the format YYYYMMDD. Default is zeroes. !!00225 * !!00226 !00227 04 PRI-DOB PIC 9(8). !00228 !00229 * !!00230 * The name of the secondary cardholder. !!00231 * This field is optional; the default !!00232 * is spaces. !!00233 * !!00234 !00235 04 SEC-NAM PIC X(40). !00236 !00237 * !!00238 * The name of a third authorized user. !!00239 * This field is optional; the default !!00240 * is spaces. !!00241 * !!00242 !00243 04 ADNL-NAM PIC X(40). !00244 !00245 * !!00246 * Mother's maiden name. This field is optional; !!00247 * the default is spaces. !!00248 * !!00249 !00250 !00251 04 OTHR-NAM PIC X(40). !00252 !00253 !00254 * !!00255 * The first line of the primary cardholder's !!00256 * street address. Default is spaces. !!00257 * !!00258 !00259 04 ADDR-1 PIC X(40). !00260 !00261 * !!00262 * The second line of the primary cardholder's !!00263 * street address. This field is optional; !!00264 * the default is spaces. !!00265 * !!00266 !00267 04 ADDR-2 PIC X(40). !00268 !00269 * !!00270 * The primary cardholder's city of !!00271 * residence. This field is optional; the !!00272 * default is spaces. !!00273 * !!00274 !00275 04 CITY PIC X(30). !00276 !00277 * !!00278 * The alpha representation of the primary !!00279 * cardholder's state of residence. This !!00280 * field may also contain the province or !!00281 * region where the primary cardholder !!00282 * resides. Refer to the FIPS Processing !!00283 * Standards Publication 6-3 for valid state !!00284 * codes. Default is spaces. !!00285 * !!00286 !00287 04 ST PIC X(30). !00288 !00289 * !!00290 * The alpha representation of the primary !!00291 * cardholder's country of residence. Refer !!00292 * to ISO 3166 (1988) manual for valid values. !!00293 * Default is spaces. !!00294 * !!00295 !00296 04 CNTRY PIC X(3). !00297 !00298 * !!00299 * The postal code/zip code for the primary !!00300 * cardholder's residence. Default is spaces. !!00301 * !!00302 !00303 04 POSTAL-CDE PIC X(16). !00304 !00305 * !!00306 * The primary cardholder's home telephone !!00307 * number. This field is optional. The !!00308 * data in this field will be left-justified; !!00309 * the default is spaces. !!00310 * !!00311 !00312 04 HOME-PHN PIC X(20). !00313 !00314 * !!00315 * The primary cardholder's work telephone !!00316 * number. This field is optional. The !!00317 * data in this field will be left-justified; !!00318 * the default is spaces. !!00319 * !!00320 !00321 04 WRK-PHN PIC X(20). !00322 !00323 * !!00324 * A third telephone number for the primary !!00325 * cardholder. This field may be used for !!00326 * a mobile/cellular telephone number. !!00327 * Default is spaces. !!00328 * !!00329 !00330 04 MOB-PHN PIC X(20). !00331 * !!00332 * Email address for the primary cardholder. !!00333 * Default is spaces. !!00334 * !!00335 !00336 04 EMAIL-ADDR PIC X(40). !00337 !00338 * !!00339 * Customer identification. This field may !!00340 * be used for a customer reference number, !!00341 * password, place of birth, or other security !!00342 * or identifying information. Default is !!00343 * spaces. !!00344 * !!00345 !00346 04 ID PIC X(30). !00347 !00348 * !!00349 * Information about the physical card. !!00350 * !!00351 !00352 02 CRD. !00353 !00354 * !!00355 * Code for the product associated with !!00356 * this card; for example, Gold or Classic. !!00357 * Default is spaces. !!00358 * !!00359 !00360 04 PROD-TYP PIC X(2). !00361 !00362 * !!00363 * Member type. Internal organization that !!00364 * owns the account. Similar to a product code !!00365 * or product type. Default is spaces. !!00366 * !!00367 !00368 04 MBR-TYP REDEFINES PROD-TYP PIC X(2). !00369 !00370 * !!00371 * Type of plastic or cardholder !!00372 * agreement. Default is spaces. !!00373 * !!00374 !00375 04 PLASTIC-TYP PIC X(2). !00376 !00377 * !!00378 * Date of last card request in the !!00379 * format YYYYMMDD. Default is zeroes. !!00380 * !!00381 !00382 04 RQST-DAT PIC 9(8). !00383 !00384 * !!00385 * Date of last pin change in the !!00386 * format YYYYMMDD. Default is zeroes. !!00387 * !!00388 !00389 04 PIN-CHNG PIC 9(8). !00390 !00391 * !!00392 * Last issue date in the format YYYYMMDD. !!00393 * Default is zeroes. !!00394 * !!00395 !00396 04 LAST-ISS PIC 9(8). !00397 !00398 04 BEGIN-DAT REDEFINES LAST-ISS PIC 9(8). !00399 !00400 * !!00401 * Emboss date in the format YYYYMMDD. !!00402 * Default is zeroes. !!00403 * !!00404 !00405 04 EMBOSS PIC 9(8). !00406 !00407 * !!00408 * Date of last CRV maintenance in the !!00409 * format YYYYMMDD. Default is zeroes. !!00410 * !!00411 !00412 04 LAST-CRV PIC 9(8). !00413 !00414 * !!00415 * Date of last address change in the !!00416 * format YYYYMMDD. Default is zeroes. !!00417 * !!00418 !00419 04 LAST-ADDR-CHNG PIC 9(8). !00420 !00421 * !!00422 * Date of last status change in the !!00423 * format YYYYMMDD. Default is zeroes. !!00424 * !!00425 !00426 04 LAST-STAT-CHNG PIC 9(8). !00427 !00428 * !!00429 * Number of cards issued. Default !!00430 * is zeroes. !!00431 * !!00432 !00433 04 NUM-ISS PIC 9(2). !00434 !00435 !00436 !00437 !00438 * !!00439 * Indicates that a cardholder has been !!00440 * blocked and why. Default is spaces. !!00441 * !!00442 !00443 04 BLK-CDE PIC X(1). !00444 !00445 * !!00446 * Reclassification code or alternate !!00447 * block code. Default is spaces. !!00448 * !!00449 !00450 04 RECLASS-CDE PIC X(1). !00451 !00452 04 ALT-BLK-CDE REDEFINES RECLASS-CDE PIC X(1). !00453 !00454 !00455 !00456 !00457 * !!00458 * Behavioral score. Valid values will be !!00459 * 000-999, with 650-750 being good, less !!00460 * that 650 is bad, more than 750 is very good. !!00461 * Default is spaces. !!00462 * !!00463 !00464 04 BHVR-SCORE PIC X(4). !00465 !00466 !00467 !00468 !00469 * !!00470 * Lifetime high amounts and balances. !!00471 * !!00472 !00473 02 LIFE-HIGH. !00474 !00475 * !!00476 * Life high cash advance amount. !!00477 * Default is zeroes. !!00478 * !!00479 !00480 04 CASH-ADV-AMT PIC 9(12). !00481 !00482 !00483 * !!00484 * Enterprise Risk Lifetime high withdrawal amount. !!00485 * !!00486 !00487 04 ER-WDL-AMT REDEFINES CASH-ADV-AMT PIC 9(12). !00488 !00489 * !!00490 * Life high purchase amount. !!00491 * Default is zeroes. !!00492 * !!00493 !00494 04 PURCH-AMT PIC 9(12). !00495 !00496 * !!00497 * Enterprise Risk Lifetime high deposit amount. !!00498 * !!00499 !00500 04 ER-DEP-AMT REDEFINES PURCH-AMT PIC 9(12). !00501 !00502 !00503 * !!00504 * Life high balance amount. !!00505 * Default is zeroes. !!00506 * !!00507 !00508 04 BAL-AMT PIC 9(12). !00509 !00510 * !!00511 * Enterprise Risk Lifetime high transfer amount. !!00512 * !!00513 !00514 04 ER-TRNSFR-AMT REDEFINES BAL-AMT PIC 9(12). !00515 !00516 !00517 02 ACCT. !00518 !00519 * !!00520 * Date the account was opened in the !!00521 * format YYYYMMDD. Default is zeroes. !!00522 * !!00523 !00524 04 OPN-DAT PIC 9(8). !00525 !00526 !00527 !00528 * !!00529 * Custom fields. !!00530 * !!00531 !00532 02 CUST. !00533 !00534 * !!00535 * Amount field to hold any user defined customized !!00536 * amount. !!00537 * !!00538 !00539 04 CUST-MSTR-AMT PIC 9(14)V99. !00540 !00541 * !!00542 * Date field to hold any user defined customized !!00543 * date. !!00544 * !!00545 !00546 04 CUST-MSTR-DAT PIC 9(8). !00547 !00548 * !!00549 * Alphanumeric field to hold user defined data. !!00550 * !!00551 !00552 04 CUST-MSTR-FLD1 PIC X(2). !00553 !00554 * !!00555 * Alphanumeric field to hold user defined data. !!00556 * !!00557 !00558 04 CUST-MSTR-FLD2 PIC X(4). !00559 !00560 !00561 !00562 !00563 !00564 !00565 02 FILLER-3 PIC X(18). !00566 !00567 END !00568